Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	584033
Missing cells	163074
Missing cells (%)	2.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	62.4 MiB
Average record size in memory	112.0 B

Variable types

Numeric	10
Categorical	4

Warnings

`Call_Start` has a high cardinality: 569222 distinct values	High cardinality
`Party_Name` has a high cardinality: 147 distinct values	High cardinality
`QueuedTime` is highly correlated with `WaitTime` and 1 other fields	High correlation
`RingTime` is highly correlated with `WaitTime vs QueuedTime`	High correlation
`WaitTime` is highly correlated with `QueuedTime` and 1 other fields	High correlation
`Queue + Ring` is highly correlated with `QueuedTime` and 1 other fields	High correlation
`WaitTime vs QueuedTime` is highly correlated with `RingTime`	High correlation
`Party_Name` has 47221 (8.1%) missing values	Missing
`TalkTime` has 32386 (5.5%) missing values	Missing
`AgentTime` has 83467 (14.3%) missing values	Missing
`Call_Start` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`QueuedTime` has 35074 (6.0%) zeros	Zeros
`RingTime` has 34598 (5.9%) zeros	Zeros
`TalkTime` has 23689 (4.1%) zeros	Zeros
`HoldTime` has 489220 (83.8%) zeros	Zeros
`WrapTime` has 71372 (12.2%) zeros	Zeros
`WaitTime vs QueuedTime` has 34598 (5.9%) zeros	Zeros

Reproduction

Analysis started	2021-02-28 17:17:10.843878
Analysis finished	2021-02-28 17:18:03.190205
Duration	52.35 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	584033
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	308375.6406
Minimum	0
Maximum	613887
Zeros	1
Zeros (%)	< 0.1%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	30083.6
Q1	155568
median	309931
Q3	461700
95-th percentile	583704.4
Maximum	613887
Range	613887
Interquartile range (IQR)	306132

Descriptive statistics

Standard deviation	177478.9503
Coefficient of variation (CV)	0.5755284367
Kurtosis	-1.194926169
Mean	308375.6406
Median Absolute Deviation (MAD)	153050
Skewness	-0.01864957845
Sum	1.801015505 × 10¹¹
Variance	3.14987778 × 10¹⁰
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
84860	1	< 0.1%
72566	1	< 0.1%
70519	1	< 0.1%
93048	1	< 0.1%
91001	1	< 0.1%
97146	1	< 0.1%
95099	1	< 0.1%
82813	1	< 0.1%
80754	1	< 0.1%
Other values (584023)	584023	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
613887	1	< 0.1%
613886	1	< 0.1%
613885	1	< 0.1%
613884	1	< 0.1%
613883	1	< 0.1%

Call_Start
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	569222
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

2020-08-03 11:15:51.000002	5
2020-09-15 09:18:49.999999	4
2020-04-21 15:18:29.999998	4
2020-10-07 11:17:35.000002	4
2020-07-07 11:11:22.999998	4
Other values (569217)	584012

Length

Max length	26
Median length	26
Mean length	26
Min length	26

Characters and Unicode

Total characters	15184858
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	554702 ?
Unique (%)	95.0%

Sample

1st row	2020-01-01 08:22:41.999998
2nd row	2020-01-01 08:54:11.999998
3rd row	2020-01-01 10:41:51.999997
4th row	2020-01-01 10:47:42.999996
5th row	2020-01-01 11:06:46.000000

Value	Count	Frequency (%)
2020-08-03 11:15:51.000002	5	< 0.1%
2020-09-15 09:18:49.999999	4	< 0.1%
2020-04-21 15:18:29.999998	4	< 0.1%
2020-10-07 11:17:35.000002	4	< 0.1%
2020-07-07 11:11:22.999998	4	< 0.1%
2020-05-05 11:52:03.999996	4	< 0.1%
2020-08-14 13:48:41.999999	4	< 0.1%
2020-05-13 13:35:56.000003	3	< 0.1%
2020-05-11 16:17:28.000000	3	< 0.1%
2020-11-02 08:07:14.000002	3	< 0.1%
Other values (569212)	583995	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-09-08	3621	0.3%
2020-06-01	3458	0.3%
2020-05-26	3432	0.3%
2020-08-03	3185	0.3%
2020-06-15	3182	0.3%
2020-05-18	3128	0.3%
2020-08-17	3121	0.3%
2020-08-24	3114	0.3%
2020-09-14	3101	0.3%
2020-07-27	3097	0.3%
Other values (52678)	1135627	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	4130772	27.2%
2	1929506	12.7%
9	1554110	10.2%
1	1441657	9.5%
-	1168066	7.7%
:	1168066	7.7%
	584033	3.8%
.	584033	3.8%
3	567830	3.7%
4	536670	3.5%
Other values (4)	1520115	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11680660	76.9%
Other Punctuation	1752099	11.5%
Dash Punctuation	1168066	7.7%
Space Separator	584033	3.8%

Most frequent character per category

Value	Count	Frequency (%)
0	4130772	35.4%
2	1929506	16.5%
9	1554110	13.3%
1	1441657	12.3%
3	567830	4.9%
4	536670	4.6%
5	489844	4.2%
8	359004	3.1%
7	345896	3.0%
6	325371	2.8%

Value	Count	Frequency (%)
:	1168066	66.7%
.	584033	33.3%

Value	Count	Frequency (%)
-	1168066	100.0%

Value	Count	Frequency (%)
	584033	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15184858	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4130772	27.2%
2	1929506	12.7%
9	1554110	10.2%
1	1441657	9.5%
-	1168066	7.7%
:	1168066	7.7%
	584033	3.8%
.	584033	3.8%
3	567830	3.7%
4	536670	3.5%
Other values (4)	1520115	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15184858	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4130772	27.2%
2	1929506	12.7%
9	1554110	10.2%
1	1441657	9.5%
-	1168066	7.7%
:	1168066	7.7%
	584033	3.8%
.	584033	3.8%
3	567830	3.7%
4	536670	3.5%
Other values (4)	1520115	10.0%

Exit_Reason
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

AgentAnswered	536828
Abandoned	43483
Redirected	3722

Length

Max length	13
Median length	13
Mean length	12.68306928
Min length	9

Characters and Unicode

Total characters	7407331
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Abandoned
2nd row	Abandoned
3rd row	Abandoned
4th row	Abandoned
5th row	Abandoned

Value	Count	Frequency (%)
AgentAnswered	536828	91.9%
Abandoned	43483	7.4%
Redirected	3722	0.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
agentanswered	536828	91.9%
abandoned	43483	7.4%
redirected	3722	0.6%

Most occurring characters

Value	Count	Frequency (%)
e	1665133	22.5%
n	1160622	15.7%
A	1117139	15.1%
d	631238	8.5%
t	540550	7.3%
r	540550	7.3%
g	536828	7.2%
s	536828	7.2%
w	536828	7.2%
b	43483	0.6%
Other values (5)	98132	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6286470	84.9%
Uppercase Letter	1120861	15.1%

Most frequent character per category

Value	Count	Frequency (%)
e	1665133	26.5%
n	1160622	18.5%
d	631238	10.0%
t	540550	8.6%
r	540550	8.6%
g	536828	8.5%
s	536828	8.5%
w	536828	8.5%
b	43483	0.7%
a	43483	0.7%
Other values (3)	50927	0.8%

Value	Count	Frequency (%)
A	1117139	99.7%
R	3722	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7407331	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	1665133	22.5%
n	1160622	15.7%
A	1117139	15.1%
d	631238	8.5%
t	540550	7.3%
r	540550	7.3%
g	536828	7.2%
s	536828	7.2%
w	536828	7.2%
b	43483	0.6%
Other values (5)	98132	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7407331	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	1665133	22.5%
n	1160622	15.7%
A	1117139	15.1%
d	631238	8.5%
t	540550	7.3%
r	540550	7.3%
g	536828	7.2%
s	536828	7.2%
w	536828	7.2%
b	43483	0.6%
Other values (5)	98132	1.3%

Party_Name
Categorical

HIGH CARDINALITY
MISSING

Distinct	147
Distinct (%)	< 0.1%
Missing	47221
Missing (%)	8.1%
Memory size	4.5 MiB

Alex Dillon	16303
Daniel Schirmer	13539
Dave Lee Wincek	13027
Timmy Moran	12643
John Gene Vura	12563
Other values (142)	468737

Length

Max length	17
Median length	16
Mean length	15.37533438
Min length	8

Characters and Unicode

Total characters	8253664
Distinct characters	51
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kyle Younglas
2nd row	Luis Torres
3rd row	Daniel Schirmer
4th row	Mike Bilfield
5th row	Chris Smucny

Value	Count	Frequency (%)
Alex Dillon	16303	2.8%
Daniel Schirmer	13539	2.3%
Dave Lee Wincek	13027	2.2%
Timmy Moran	12643	2.2%
John Gene Vura	12563	2.2%
Alex Baltas	12466	2.1%
Butch Herten	11823	2.0%
Mike Pascaru	11626	2.0%
Alex Hord	11000	1.9%
Dustin Pollock	10975	1.9%
Other values (137)	410847	70.3%
(Missing)	47221	8.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
alex	56828	5.2%
mike	43851	4.0%
john	25117	2.3%
matt	21582	2.0%
dan	21579	2.0%
dillon	19747	1.8%
joe	18440	1.7%
connor	17411	1.6%
daniel	15998	1.5%
schirmer	15997	1.5%
Other values (146)	842664	76.7%

Most occurring characters

Value	Count	Frequency (%)
	2121807	25.7%
e	690761	8.4%
a	554492	6.7%
n	493906	6.0%
r	427038	5.2%
l	386094	4.7%
o	354832	4.3%
i	353059	4.3%
t	245160	3.0%
h	183199	2.2%
Other values (41)	2443316	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5012556	60.7%
Space Separator	2121807	25.7%
Uppercase Letter	1118900	13.6%
Other Punctuation	401	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	690761	13.8%
a	554492	11.1%
n	493906	9.9%
r	427038	8.5%
l	386094	7.7%
o	354832	7.1%
i	353059	7.0%
t	245160	4.9%
h	183199	3.7%
c	181461	3.6%
Other values (15)	1142554	22.8%

Value	Count	Frequency (%)
M	152073	13.6%
S	101135	9.0%
D	100561	9.0%
B	96273	8.6%
A	91910	8.2%
C	89153	8.0%
J	76684	6.9%
T	62976	5.6%
K	61982	5.5%
L	39264	3.5%
Other values (14)	246889	22.1%

Value	Count	Frequency (%)
	2121807	100.0%

Value	Count	Frequency (%)
*	401	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6131456	74.3%
Common	2122208	25.7%

Most frequent character per script

Value	Count	Frequency (%)
e	690761	11.3%
a	554492	9.0%
n	493906	8.1%
r	427038	7.0%
l	386094	6.3%
o	354832	5.8%
i	353059	5.8%
t	245160	4.0%
h	183199	3.0%
c	181461	3.0%
Other values (39)	2261454	36.9%

Value	Count	Frequency (%)
	2121807	> 99.9%
*	401	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8253664	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	2121807	25.7%
e	690761	8.4%
a	554492	6.7%
n	493906	6.0%
r	427038	5.2%
l	386094	4.7%
o	354832	4.3%
i	353059	4.3%
t	245160	3.0%
h	183199	2.2%
Other values (41)	2443316	29.6%

channel
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

SEO	430987
PPC	153046

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1752099
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SEO
2nd row	SEO
3rd row	SEO
4th row	SEO
5th row	SEO

Value	Count	Frequency (%)
SEO	430987	73.8%
PPC	153046	26.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
seo	430987	73.8%
ppc	153046	26.2%

Most occurring characters

Value	Count	Frequency (%)
S	430987	24.6%
E	430987	24.6%
O	430987	24.6%
P	306092	17.5%
C	153046	8.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1752099	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	430987	24.6%
E	430987	24.6%
O	430987	24.6%
P	306092	17.5%
C	153046	8.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1752099	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	430987	24.6%
E	430987	24.6%
O	430987	24.6%
P	306092	17.5%
C	153046	8.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1752099	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	430987	24.6%
E	430987	24.6%
O	430987	24.6%
P	306092	17.5%
C	153046	8.7%

QueuedTime
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	189
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.31408328
Minimum	0
Maximum	188
Zeros	35074
Zeros (%)	6.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	4
Q3	13
95-th percentile	77
Maximum	188
Range	188
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	27.83661022
Coefficient of variation (CV)	1.817713128
Kurtosis	10.81378292
Mean	15.31408328
Median Absolute Deviation (MAD)	2
Skewness	3.158660053
Sum	8943930
Variance	774.8768683
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	122481	21.0%
3	74541	12.8%
2	56806	9.7%
5	36638	6.3%
1	36112	6.2%
0	35074	6.0%
6	12844	2.2%
7	11634	2.0%
9	11370	1.9%
8	11119	1.9%
Other values (179)	175414	30.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35074	6.0%
1	36112	6.2%
2	56806	9.7%
3	74541	12.8%
4	122481	21.0%

Value	Count	Frequency (%)
188	25	< 0.1%
187	44	< 0.1%
186	40	< 0.1%
185	61	< 0.1%
184	71	< 0.1%

RingTime
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.620021471
Minimum	0
Maximum	48
Zeros	34598
Zeros (%)	5.9%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	7
Q3	10
95-th percentile	16
Maximum	48
Range	48
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.585284004
Coefficient of variation (CV)	0.6017416121
Kurtosis	0.286879361
Mean	7.620021471
Median Absolute Deviation (MAD)	3
Skewness	0.6253447648
Sum	4450344
Variance	21.0248294
Monotocity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
6	57029	9.8%
5	54987	9.4%
7	51720	8.9%
4	50194	8.6%
8	49708	8.5%
9	43935	7.5%
10	36863	6.3%
3	35122	6.0%
0	34598	5.9%
11	29988	5.1%
Other values (23)	139889	24.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34598	5.9%
1	8918	1.5%
2	22140	3.8%
3	35122	6.0%
4	50194	8.6%

Value	Count	Frequency (%)
48	1	< 0.1%
43	1	< 0.1%
34	1	< 0.1%
29	2	< 0.1%
28	1	< 0.1%

TalkTime
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	922
Distinct (%)	0.2%
Missing	32386
Missing (%)	5.5%
Infinite	0
Infinite (%)	0.0%

Mean	176.8936874
Minimum	0
Maximum	921
Zeros	23689
Zeros (%)	4.1%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	43
median	129
Q3	243
95-th percentile	557
Maximum	921
Range	921
Interquartile range (IQR)	200

Descriptive statistics

Standard deviation	174.5015169
Coefficient of variation (CV)	0.9864767895
Kurtosis	2.388564124
Mean	176.8936874
Median Absolute Deviation (MAD)	94
Skewness	1.555612029
Sum	97582872
Variance	30450.77939
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	23689	4.1%
20	4149	0.7%
19	4034	0.7%
18	4022	0.7%
21	4008	0.7%
22	3876	0.7%
17	3871	0.7%
23	3744	0.6%
24	3723	0.6%
16	3692	0.6%
Other values (912)	492839	84.4%
(Missing)	32386	5.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	23689	4.1%
1	1770	0.3%
2	1963	0.3%
3	1814	0.3%
4	1531	0.3%

Value	Count	Frequency (%)
921	28	< 0.1%
920	24	< 0.1%
919	27	< 0.1%
918	16	< 0.1%
917	32	< 0.1%

HoldTime
Real number (ℝ_≥0)

ZEROS

Distinct	156
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.030650665
Minimum	0
Maximum	155
Zeros	489220
Zeros (%)	83.8%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20
Maximum	155
Range	155
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	17.4222695
Coefficient of variation (CV)	4.322445915
Kurtosis	31.49375239
Mean	4.030650665
Median Absolute Deviation (MAD)	0
Skewness	5.434796955
Sum	2354033
Variance	303.5354746
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	489220	83.8%
1	21291	3.6%
2	10392	1.8%
3	8147	1.4%
4	5553	1.0%
5	4174	0.7%
6	3443	0.6%
7	2646	0.5%
8	2040	0.3%
9	1386	0.2%
Other values (146)	35741	6.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	489220	83.8%
1	21291	3.6%
2	10392	1.8%
3	8147	1.4%
4	5553	1.0%

Value	Count	Frequency (%)
155	64	< 0.1%
154	73	< 0.1%
153	87	< 0.1%
152	74	< 0.1%
151	69	< 0.1%

WrapTime
Real number (ℝ_≥0)

ZEROS

Distinct	1004
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	120.1054666
Minimum	0
Maximum	1003
Zeros	71372
Zeros (%)	12.2%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8
median	62
Q3	171
95-th percentile	442
Maximum	1003
Range	1003
Interquartile range (IQR)	163

Descriptive statistics

Standard deviation	158.4519334
Coefficient of variation (CV)	1.319273284
Kurtosis	6.101507893
Mean	120.1054666
Median Absolute Deviation (MAD)	59
Skewness	2.238245217
Sum	70145556
Variance	25107.01519
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	71372	12.2%
4	14652	2.5%
5	13638	2.3%
3	13119	2.2%
6	11673	2.0%
7	9744	1.7%
8	8618	1.5%
9	7370	1.3%
10	6641	1.1%
11	5857	1.0%
Other values (994)	421349	72.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	71372	12.2%
1	1952	0.3%
2	5538	0.9%
3	13119	2.2%
4	14652	2.5%

Value	Count	Frequency (%)
1003	16	< 0.1%
1002	22	< 0.1%
1001	15	< 0.1%
1000	17	< 0.1%
999	12	< 0.1%

WaitTime
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	189
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.93410475
Minimum	0
Maximum	188
Zeros	1839
Zeros (%)	0.3%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	14
Q3	22
95-th percentile	81
Maximum	188
Range	188
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	26.9169826
Coefficient of variation (CV)	1.173666158
Kurtosis	10.86937574
Mean	22.93410475
Median Absolute Deviation (MAD)	5
Skewness	3.11753594
Sum	13394274
Variance	724.5239525
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	43238	7.4%
9	40832	7.0%
12	38079	6.5%
11	37322	6.4%
8	36780	6.3%
14	31381	5.4%
13	29053	5.0%
7	27199	4.7%
16	23353	4.0%
15	21062	3.6%
Other values (179)	255734	43.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1839	0.3%
1	842	0.1%
2	1286	0.2%
3	2095	0.4%
4	6000	1.0%

Value	Count	Frequency (%)
188	94	< 0.1%
187	117	< 0.1%
186	95	< 0.1%
185	114	< 0.1%
184	102	< 0.1%

Queue + Ring
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	189
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.93410475
Minimum	0
Maximum	188
Zeros	1839
Zeros (%)	0.3%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	10
median	14
Q3	22
95-th percentile	81
Maximum	188
Range	188
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	26.9169826
Coefficient of variation (CV)	1.173666158
Kurtosis	10.86937574
Mean	22.93410475
Median Absolute Deviation (MAD)	5
Skewness	3.11753594
Sum	13394274
Variance	724.5239525
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	43238	7.4%
9	40832	7.0%
12	38079	6.5%
11	37322	6.4%
8	36780	6.3%
14	31381	5.4%
13	29053	5.0%
7	27199	4.7%
16	23353	4.0%
15	21062	3.6%
Other values (179)	255734	43.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1839	0.3%
1	842	0.1%
2	1286	0.2%
3	2095	0.4%
4	6000	1.0%

Value	Count	Frequency (%)
188	94	< 0.1%
187	117	< 0.1%
186	95	< 0.1%
185	114	< 0.1%
184	102	< 0.1%

WaitTime vs QueuedTime
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.620021471
Minimum	0
Maximum	48
Zeros	34598
Zeros (%)	5.9%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	7
Q3	10
95-th percentile	16
Maximum	48
Range	48
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.585284004
Coefficient of variation (CV)	0.6017416121
Kurtosis	0.286879361
Mean	7.620021471
Median Absolute Deviation (MAD)	3
Skewness	0.6253447648
Sum	4450344
Variance	21.0248294
Monotocity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
6	57029	9.8%
5	54987	9.4%
7	51720	8.9%
4	50194	8.6%
8	49708	8.5%
9	43935	7.5%
10	36863	6.3%
3	35122	6.0%
0	34598	5.9%
11	29988	5.1%
Other values (23)	139889	24.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34598	5.9%
1	8918	1.5%
2	22140	3.8%
3	35122	6.0%
4	50194	8.6%

Value	Count	Frequency (%)
48	1	< 0.1%
43	1	< 0.1%
34	1	< 0.1%
29	2	< 0.1%
28	1	< 0.1%

AgentTime
Real number (ℝ_≥0)

MISSING

Distinct	1767
Distinct (%)	0.4%
Missing	83467
Missing (%)	14.3%
Infinite	0
Infinite (%)	0.0%

Mean	319.4068694
Minimum	0
Maximum	2037
Zeros	49
Zeros (%)	< 0.1%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	29
Q1	120
median	252
Q3	441
95-th percentile	867
Maximum	2037
Range	2037
Interquartile range (IQR)	321

Descriptive statistics

Standard deviation	264.9798105
Coefficient of variation (CV)	0.829599598
Kurtosis	1.963352043
Mean	319.4068694
Median Absolute Deviation (MAD)	151
Skewness	1.350473477
Sum	159884219
Variance	70214.29996
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29	1598	0.3%
28	1581	0.3%
27	1567	0.3%
25	1542	0.3%
33	1542	0.3%
32	1539	0.3%
34	1537	0.3%
30	1537	0.3%
31	1521	0.3%
26	1520	0.3%
Other values (1757)	485082	83.1%
(Missing)	83467	14.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	49	< 0.1%
1	21	< 0.1%
2	103	< 0.1%
3	269	< 0.1%
4	315	0.1%

Value	Count	Frequency (%)
2037	1	< 0.1%
1954	1	< 0.1%
1934	1	< 0.1%
1907	1	< 0.1%
1891	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Call_Start	Exit_Reason	Party_Name	channel	QueuedTime	TalkTime	WaitTime	Queue + Ring	AgentTime
0	0	2020-01-01 08:22:41.999998	Abandoned	NaN	SEO	11	NaN	11	11	NaN
1	1	2020-01-01 08:54:11.999998	Abandoned	NaN	SEO	115	NaN	115	115	NaN
2	2	2020-01-01 10:41:51.999997	Abandoned	NaN	SEO	25	NaN	25	25	NaN
3	3	2020-01-01 10:47:42.999996	Abandoned	NaN	SEO	60	NaN	60	60	NaN
4	4	2020-01-01 11:06:46.000000	Abandoned	NaN	SEO	20	NaN	20	20	NaN
5	5	2020-01-01 11:25:49.000002	Abandoned	NaN	SEO	7	NaN	7	7	NaN
6	6	2020-01-01 15:08:38.000002	Abandoned	NaN	SEO	23	NaN	23	23	NaN
7	7	2020-01-01 16:38:39.000005	Abandoned	NaN	SEO	119	NaN	119	119	NaN
8	8	2020-01-01 16:53:30.999999	Abandoned	NaN	SEO	12	NaN	12	12	NaN
9	9	2020-01-01 16:58:58.999999	Abandoned	NaN	SEO	20	NaN	20	20	NaN

Last rows

	df_index	Call_Start	Exit_Reason	Party_Name	channel	QueuedTime	RingTime	TalkTime	WrapTime	WaitTime	Queue + Ring	WaitTime vs QueuedTime	AgentTime
584023	613878	2021-02-21 12:07:37.000004	AgentAnswered	Matthew Duff	SEO	11	11	210.0	0.0	22	22	11	210.0
584024	613879	2021-02-21 12:08:27.000004	AgentAnswered	Junior Fetchet	SEO	8	8	133.0	2.0	16	16	8	135.0
584025	613880	2021-02-21 12:13:19.000001	AgentAnswered	Matt Tashjian	SEO	15	15	68.0	42.0	30	30	15	110.0
584026	613881	2021-02-21 12:13:54.000002	AgentAnswered	Matthew Duff	SEO	18	6	92.0	2.0	24	24	6	94.0
584027	613882	2021-02-21 12:14:41.999997	AgentAnswered	Lauren Basch	SEO	17	5	40.0	0.0	22	22	5	40.0
584028	613883	2021-02-21 12:17:38.999996	AgentAnswered	Matt Tashjian	SEO	14	14	121.0	2.0	28	28	14	123.0
584029	613884	2021-02-21 12:18:55.000003	AgentAnswered	Meredith Chesney	SEO	4	4	289.0	1.0	8	8	4	290.0
584030	613885	2021-02-21 12:20:36.000004	Abandoned	NaN	SEO	8	0	NaN	0.0	8	8	0	NaN
584031	613886	2021-02-21 12:22:32.999998	AgentAnswered	Matt Tashjian	SEO	17	17	55.0	12.0	34	34	17	67.0
584032	613887	2021-02-21 12:24:08.999997	AgentAnswered	Junior Fetchet	SEO	7	7	201.0	42.0	14	14	7	243.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows